﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>AdventureWorks Report Samples</title>
    
    
    
    <style TYPE="text/css">
body
{
background: #FFFFFF;
color: #000000;
font-family:    Verdana;
font-size: medium;
font-style: normal;
font-weight: normal;
margin-top: 0;
margin-bottom:  0;
margin-left:    0;
margin-right:   0;
width:  100%;
}

div.#mainSection
{
font-size: 70%;
width: 100%;
padding-left:    10;
margin-right: 10;
}

div.#mainBody
{
font-size: 90%;
margin-top: 10;
padding-bottom: 20;
}

div.#header
{
background-color: #D2D2D2;
padding-top:    0;
padding-bottom: 0;
padding-left:   10;
padding-right:  0;
width:          100%;
}

div.#header table
{
border-bottom-color: #C8CDDE;
border-bottom-style: solid;
border-bottom-width: 1;
width:  100%;
}

span.#runningHeaderText
{
color: #003399;
font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
font-size: 120%;
font-weight: 600;
}

div.#header table td
{
color: #000000;
font-size: 70%;
margin-top: 0;
margin-bottom:  0;
padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
padding-bottom: 2;
padding-top: 5;
}

div.#header table.#bottomTable
{
border-top-color: #FFFFFF;
border-top-style: solid;
border-top-width: 1;
text-align: left;
}

div.#footer
{
font-size: 90%;
margin-top: 0;
margin-bottom:  0;
margin-left:    -5;
margin-right:   0;
padding-top:    2;
padding-bottom: 2;
padding-left:   0;
padding-right:  0;
width:  100%;
}

hr.#footerHR
{
border-bottom-color: #EEEEFF;
border-bottom-style: solid;
border-bottom-width: 1;
border-top-color: C8CDDE;
border-top-style: solid;
border-top-width: 1;
height: 3;
color: #D2D2D2;
}

div.section
{
padding-top:    2;
padding-bottom: 2;
padding-right:  15;
width:  100%;
}

.heading
{
color:          #000000;
font-weight:    bold;
margin-top:     18;
margin-bottom:  8;
}

h1.heading
{
color: #000000;
font-size:  150%;
}

.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      150%;
margin-bottom:  4;
}

h2.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      130%;
}
h3.subHeading
{
color:  #000000;
font-size: 125%;
font-weight: bold;
}

h4.subHeading
{
color: #000000;
font-size: 110%;
font-weight: bold;
}

h4.procedureHeading
{
color: #000080;
font-size: 110%;
font-weight: bold;
}

h5.subHeading
{
color: #000000;
font-size: 100%;
font-weight: bold;
}

img
{
padding-bottom: 10;
}

img.toggle
{
border: 0;
margin-right: 5;
padding-bottom: 10;
}

img.copyCodeImage
{
border: 0;
margin: 1;
margin-right: 3;
padding-bottom: 10;
}

img.downloadCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.viewCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.note
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
border: 0;
margin-left: 10;
vertical-align: middle;
padding-bottom: 10;
}

img.#toggleAllImage
{
margin-left: 4;
vertical-align: middle;
padding-bottom: 10;
}

div.#mainSection table
{
border: 0;
font-size: 100%;
width:  100%;
margin-top: 5px;
margin-bottom: 15px;
}

div.#mainSection table tr
{
vertical-align: top;
}

div.#mainSection table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td
{
background: #F2F2F2;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td.imageCell
{
white-space: nowrap;
}

div.code
{
width: 98%;
}

div.code table
{
border: 0;
font-size: 95%;
margin-bottom: 5;
width: 100%
}

div.code table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
font-weight: bold;
padding-left: 5;
padding-right: 5;
}

div.code table td
{
background: #CCCCCC;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
padding-top: 5;
}

div.alert
{
margin-left: 10;
width: 98%;
}

div.alert table
{
border: 1;
font-size: 100%;
width:  100%;
border: solid 1 #DEDFEF;
}

div.alert table th
{
text-align: left;
background: #D8D8D8;
border-bottom-width: 0;
color: #000000;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

div.alert table td
{
background: #FFFFFF;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

span.copyCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
float: right;
display: inline;
text-align: right;
}

.downloadCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

.viewCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

div.code pre
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

code
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

dl
{
margin-top: 0;
padding-left:   1;
}

dd
{
margin-bottom:  0;
margin-left:    0;
padding-left:   20;
}

dd p
{
margin-top: 5;
}

ul
{
margin-left: 17;
list-style-type: disc;
}

ul ul
{
margin-bottom: 4;
margin-left: 17;
margin-top: 3;
list-style-type: disc;
}

ol
{
margin-left: 24;
list-style-type: decimal;
}

ol ol
{
margin-left: 24;
margin-top: 3;
list-style-type: lower-alpha;
}

li
{
margin-top: 0;
margin-bottom: 0;
padding-bottom: 0;
padding-top: 0;
margin-left: 5;
}

p
{
margin-bottom: 15;
}

.tip
{
color:  #0000FF;
font-style: italic;
cursor:hand;
text-decoration:underline;
}

.math
{
font-family: Times New Roman;
font-size: 125%
}
.sourceCodeList
{
font-family: Verdana;
font-size: 90%;
}

pre.viewCode
{
width: 100%;
overflow: auto;
}

li:hover table, li.over table
{
background-color: #C0C0C0;
}

li:hover ul, li.over ul
{
background-color: #d2d2d2;
border: 1px solid #000;
display: block;
}
            </style>
  </head>
  <body>
    <!--Topic built:08/05/2008 01:28:33-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="nsrTitle">AdventureWorks Report Samples</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      <div id="mainBody"><p> 08/05/2008 01:28:33</p>
        
        <font color="DarkGray"> </font><p /> 
        <span id="changeHistory">
        </span>
    <p>The AdventureWorks 2008 sample reports are a set of predefined report definition files that use the <b>AdventureWorks</b> 2008 databases as data sources. You can upload and view each report separately; however, some reports are designed to work together through the use of links. You can use the sample reports to familiarize yourself with the capabilities of SQL Server 2008 Reporting Services (SSRS) or as templates for designing new reports.</p>
    <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Important: </th></tr><tr><td>
      SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see <a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Considerations for Installing SQL Server Samples and Sample Databases</a>.<p />
    </td></tr></table><p /></div>
    <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
      If you are using SQL Server 2008 Express with Advanced Services, you must modify the report server URL before publishing the sample reports to the report server. Also, be aware that the Sales Reason Comparison report is not supported. That report requires SQL Server 2008 Analysis Services (SSAS), which is not available in SQL Server 2008 Express. <p />
    </td></tr></table><p /></div>
  <h1 class="heading">Scenario</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">
        Adventure Works Cycles 2008 publishes product and sales information that is accessed by employees throughout the company. The reports present this data in a variety of formats. Users can view these reports on demand by opening them in Report Manager.</p>
    </content></div><h1 class="heading">Language</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Report Definition Language (RDL)</p>
    </content></div><h1 class="heading">Features</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks 2008 sample reports demonstrate a wide range of report features. The following table provides descriptions that explain which features are implemented in each report.</p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>Company Sales 2008</p>
          </td>
          <td>
            <p>
              Adventure Works Cycles sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images.</p>
          </td>
        </tr><tr>
          <td>
            <p>Employee Sales Summary 2008</p>
          </td>
          <td>
            <p>
              Adventure Works Cycles sales for an individual employee. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters.</p>
          </td>
        </tr><tr>
          <td>
            <p>Product Catalog 2008</p>
          </td>
          <td>
            <p>The Adventure Works Cycles full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.</p>
          </td>
        </tr><tr>
          <td>
            <p>Product Line Sales 2008</p>
          </td>
          <td>
            <p>
              Adventure Works Cycles top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of tables, charts, multivalued parameters, end-user sorting, calculated fields, and drillthrough links.</p>
          </td>
        </tr><tr>
          <td>
            <p>Sales Order Detail 2008</p>
          </td>
          <td>
            <p>Detail of an individual Adventure Works Cycles order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.</p>
          </td>
        </tr><tr>
          <td>
            <p>Territory Sales 2008</p>
          </td>
          <td>
            <p>
              Adventure Works Cycles sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. This report illustrates the use of a table data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of drillthrough links and conditional formatting.</p>
          </td>
        </tr><tr>
          <td>
            <p>Store Contacts 2008</p>
          </td>
          <td>
            <p>AdventureWorks store contacts. Each store can have one or more store contacts. This report is a subreport used in Sales Order Detail to show all contacts for a store and a drillthrough report for the Product Line sales chart. The border style for the table is None so that borders do not appear in the main report. Note that the page header and footer content are not included when the report is a subreport. </p>
          </td>
        </tr><tr>
          <td>
            <p>Sales Trend 2008</p>
          </td>
          <td>
            <p>AdventureWorks sales trend analysis that compares year over year (Y/Y) growth for products by category and subcategory. This report illustrates the following features: a Tablix with conditionally hidden static columns, repeat column and row headers, and KeepTogether static Tablix member; the aggregate function Previous that calculates Y/Y trends; custom code; conditional font, background cell color, KPI images, and drillthrough parameters.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Prerequisites</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Your system must meet the following requirements to use the sample reports.</p>
    </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <h3 class="subHeading" xmlns="">Server</h3><div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
          <ul xmlns=""><li>
              
                Microsoft SQL Server 2008 Reporting Services (SSRS) (Evaluation, Standard, Developer, or Enterprise), or SQL Server 2008 Express with Advanced Services.<br />
            </li><li>
              
                Microsoft SQL Server 2008. <br />
            </li><li>
              
                <b>AdventureWorks</b> 2008 sample database .<br />
            </li></ul>
        </content></div>
      <h3 class="subHeading" xmlns="">Client</h3><div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
          <ul xmlns=""><li>
              
                Microsoft Internet Explorer 6.0 with scripting enabled<br />
            </li><li>
              
                Business Intelligence Development Studio (optional)<br />
              <div class="alert"><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
                Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.<p />
              </td></tr></table><p /></div>
            </li></ul>
        </content></div>
    </sections></div><h1 class="heading">Installing Samples</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see <a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Considerations for Installing SQL Server Samples and Sample Databases</a>.</p>
    </content></div><h1 class="heading">Deploying the AdventureWorks Sample Reports</h1><div id="sectionSection5" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <ol xmlns=""><li>
          On the Business Intelligence Development Studio toolbar, click <b>File</b>, point to <b>Open</b>, and then click <b>Project/Solution</b>.<br />
        </li><li>
          Browse to &lt;<i>drive</i>:&gt;\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Report Samples\AdventureWorks Sample Reports, select the file AdventureWorks 2008 Sample Reports.sln and click <b>Open</b>.<br />
        </li><li>
          If you are using SQL Server Express with Advanced Services, you must modify the target report server URL property and change the default connection string that specifies a connection to the AdventureWorks 2008 sample database. The default values in this sample are not correct for a SQL Server Express installation:<br />
          <ol><li>
              On the <b>Project</b> menu, select <b>Properties</b>.<br />
            </li><li>
              In <b>OverwriteDataSources</b>, select <b>True</b>.<br />
            </li><li>
              In <b>TargetServerURL</b>, type the following URL:<br />
              
                <code>http://localhost/reportserver$SQLExpress</code>
              <br />
            </li><li>
              Click <b>OK</b> to close the Solution Property Pages dialog box.<br />
            </li><li>
              In Solution Explorer, in <b>Shared Data Sources</b>, double-click <b>AdventureWorks.rds</b>.<br />
            </li><li>
              In the <b>Shared Data Source</b> dialog box, in the <b>General</b> tab, modify the connection string to use the following value:<br />
              
                <code>Data Source=localhost\SQLExpress; Initial Catalog=AdventureWorks2008</code>
              <br />
            </li><li>
              Click <b>OK</b> to close the <b>Shared Data Source</b> dialog box.<br />
            </li></ol>
        </li><li>
          On the standard toolbar, select the Production solution configuration. (The default configuration is Debug.)<br />
        </li><li>
          On the Build menu, click <b>Deploy AdventureWorks 2008 Sample Reports</b>. When you deploy the solution, the reports are published to the report server.<br />
        </li></ol>
    </content></div><h1 class="heading">Viewing Report Samples in Report Manager</h1><div id="sectionSection6" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">After you publish the report samples, you can view them in Report Manager. Viewing reports requires the following permissions:</p>
      <ul xmlns=""><li>
          You must have permission to log on to the local SQL Server Database Engine that hosts the <b>AdventureWorks</b> database. By default, report data sources are configured to use Windows integrated security. Your Windows account credentials are used to log on to the database.<br />
        </li><li>
          You must have a role assignment that grants you access to the report. If you are a local administrator on the computer, all of these permissions are granted automatically. If you are not a local administrator, you must configure role assignments and login permissions before you view the report.<br />
        </li></ul>
    </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
        </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
          <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
            </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                  <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                    </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                      <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                        </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                          <div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                            </content><sections xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                              <h5 class="subHeading" xmlns="">To view a report in Report Manager</h5><div class="subSection" xmlns=""><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
                                  <ol xmlns=""><li>
                                      Open a browser window. Report Manager requires Internet Explorer 6.0 or later with scripting enabled.<br />
                                    </li><li>
                                      Type the Report Manager URL in the address bar of a Web browser. By default, the URL is http://&lt;<i>webservername</i>&gt;/reports. If you are using SQL Server Express, the default URL is http://localhost/reports$SQLExpress.<br />
                                    </li><li>
                                      Navigate to the folder that contains the reports. By default, it is the AdventureWorks Sample Reports folder.<br />
                                    </li><li>
                                      Click the name of the report that you want to open.<br />
                                    </li></ol>
                                </content></div>
                            </sections></div>
                        </sections></div>
                    </sections></div>
                </sections></div>
            </sections></div>
        </sections></div>
    </sections></div><h1 class="heading">See Also</h1><div id="seeAlsoSection" class="section" name="collapseableSection"><h4 class="subHeading">Tasks</h4><a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Considerations for Installing SQL Server Samples and Sample Databases</a><br /><br />
		<h4 class="subHeading">
			Help and Information
		</h4>
		<b>
			
			Getting SQL Server 2008 Assistance
		</b>
	</div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
			
			© 2008 Microsoft Corporation. All rights reserved.
		</div>
    </div>
  </body>
</html>